package com.iafme.dto.res;

import cn.zhxu.bs.bean.DbField;
import cn.zhxu.bs.bean.SearchBean;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * @author summer
 * @version 1.0
 * @date 2025/3/28 11:06
 */
@Data
@SearchBean(tables = "iafme_order_course c " +
        "LEFT JOIN iafme_order o ON c.order_id=o.id " +
        "LEFT JOIN iafme_member m ON o.memberId=m.id " +
        "LEFT JOIN iafme_course ic ON c.course_id=ic.id")
public class SearchCourseResDTO implements Serializable {

     @DbField("o.admissionNum")
     private String admissionNum;

     @DbField("ic.name")
     private String name;

     @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
     @DbField("ic.courseDate")
     private Date courseDate;

     @DbField("c.score")
     private Integer score;

     @DbField("m.name")
     private String memberName;

     @DbField("o.project_id")
     private Integer projectId;

     @DbField("o.level_id")
     private Integer levelId;

     @DbField("session_id")
     private Integer showingsId;

     @DbField("m.idCard")
     private String idCard;


     @DbField("o.status")
     private Integer status;

}
